How to: Add a header to worksheet.
Solution:
Select 'Page Setup...' from the 'File' menu and click 'Custom Header...' on the 'Header/Footer' properties sheet.
1) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
2) Click 'Header/Footer' tab.
3) Click 'Custom Header...'. (The Header dialog box appears.)
NOTE: The header part of a sheet is divided into three sections: the Left Section, the Center Section, and the Right Section. The Left Section aligns the header to the left margin. The Center Section centers the header. The Right Section aligns the header to the right margin.
4) Select the desired section by clicking on the corresponding list box.
5) Type the desired header information by typing the information or by choosing the appropriate button(s) in the dialog box.
NOTE: The buttons available are 'Page Number', 'Total Pages', 'Date', 'Time', 'Filename', and 'Sheet Name'.
6) (Optional) Format the style of the header.
a) Click 'Font'. (The Font dialog box appears.)
b) Specify the desired font attributes in the dialog box.
c) Click 'OK'. (The Header dialog box reappears.)
7) Click 'OK'. (The Page Setup dialog box reappears.)
8) Click 'OK'.